﻿// =================================================================== 
// 项目说明
//====================================================================



// 负责人：
// ===================================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using CommonLib.IDAL;
using CommonLib.DALFactory;
using CommonLib.BLL;
using CommonLib.Model;

namespace CommonLib.BLL
{
    public class CommLibStoreProcedure
    {
		#region ----------变量定义----------
		///<summary>
		///
		///</summary>
		public static readonly ICommLibStoreProcedureDAL _SPdal=(ICommLibStoreProcedureDAL)DataAccessFactory.CreateObject("CommLibStoreProcedureDAL");
		#endregion
		
		public CommLibStoreProcedure()
		{
		}
		
		#region 无返回值，无事务

        public static Int32 GETNEWIDFORCODE(string _MAT_NO)
        {
            return _SPdal.GETNEWIDFORCODE(_MAT_NO);
        }

        public static Int32 LeadBidder(string _Bidder_ID)
        {
            return _SPdal.LeadBidder(_Bidder_ID);
        }

		public static string FNYX_GETPRICEINFO(string OLTAGEID,string RICEKINDID)
		{
			return _SPdal.FNYX_GETPRICEINFO(OLTAGEID,RICEKINDID);
		}
		
		public static Int32 GETNEWIDFORMAT(string _NAME,string _TABLE,string _FIELD,string UR_FORMAT)
		{
			return _SPdal.GETNEWIDFORMAT(_NAME,_TABLE,_FIELD,UR_FORMAT);
		}
		
		public static Int32 GETNEWIDFORTABLE(string _NAME,string _TABLE,string _FIELD)
		{
			return _SPdal.GETNEWIDFORTABLE(_NAME,_TABLE,_FIELD);
		}
		
		public static void PROC_GETNEWIDFORTABLEBATCH(string ABNAME,string _FIELD,Int32 DDCOUNT,ref Int32 EWID_VAR)
		{
			 _SPdal.PROC_GETNEWIDFORTABLEBATCH(ABNAME,_FIELD,DDCOUNT,ref EWID_VAR);
		}

        public static Int32 PROC_GETNEWSNFORTABLE2(string _NAME, string _TABLE, string _FIELD, string UR_FORMAT)
        {
            return _SPdal.PROC_GETNEWSNFORTABLE2(_NAME, _TABLE, _FIELD, UR_FORMAT);
        }

        public static Int32 PROC_CREATEFEEMONTHINOUTRPT(string _STOREROOMID, string _FEEMONTH, string _START_TIME, string _END_TIME,string _CREATOR)
        {
            return _SPdal.PROC_CREATEFEEMONTHINOUTRPT(_STOREROOMID, _FEEMONTH, _START_TIME, _END_TIME, _CREATOR);
        }

        public static Int32 PROC_CreateFeeMonthUseRpt(string _STOREROOMID, string _FEEMONTH, string _START_TIME, string _END_TIME, string _CREATOR, string _MAIN_DEPT)
        {
            return _SPdal.PROC_CreateFeeMonthUseRpt(_STOREROOMID, _FEEMONTH, _START_TIME, _END_TIME, _CREATOR, _MAIN_DEPT);
        }

        public static DataSet ExecPro(DataTable dt, string Pname)
        {
            return _SPdal.ExecPro(dt,Pname);
        }

		#endregion	
		
		#region 无返回值，传入事务

		public static string FNYX_GETPRICEINFO(MyTransaction lyTans,string OLTAGEID,string RICEKINDID)
		{
			return _SPdal.FNYX_GETPRICEINFO(lyTans.dbTrans,OLTAGEID,RICEKINDID);
		}
		
		public static Int32 GETNEWIDFORMAT(MyTransaction lyTans,string _NAME,string _TABLE,string _FIELD,string UR_FORMAT)
		{
			return _SPdal.GETNEWIDFORMAT(lyTans.dbTrans,_NAME,_TABLE,_FIELD,UR_FORMAT);
		}
		
		public static Int32 GETNEWIDFORTABLE(MyTransaction lyTans,string _NAME,string _TABLE,string _FIELD)
		{
			return _SPdal.GETNEWIDFORTABLE(lyTans.dbTrans,_NAME,_TABLE,_FIELD);
		}
		
		public static void PROC_GETNEWIDFORTABLEBATCH(MyTransaction lyTans,string ABNAME,string _FIELD,Int32 DDCOUNT,ref Int32 EWID_VAR)
		{
			 _SPdal.PROC_GETNEWIDFORTABLEBATCH(lyTans.dbTrans,ABNAME,_FIELD,DDCOUNT,ref EWID_VAR);
		}

        public static string GetNewSNForTableWithNewid(string Charge_No, int Begin_Id)
        {
            return _SPdal.GetNewSNForTableWithNewid(Charge_No, Begin_Id);
        }

        public static string RunProcess(string Condations, int FeePay_id, string FEEPAY_NO, string apply_user, decimal feepay_money, string feepay_note)
        {
            return _SPdal.RunProcess(Condations, FeePay_id, FEEPAY_NO, apply_user, feepay_money, feepay_note);
        }

        public static int CreateDeptCheckMonthRptByMode(int storeroom_id, string checkmonth, string start_time, string end_time, string creator)
        {
            return _SPdal.CreateDeptCheckMonthRptByMode(storeroom_id,checkmonth,start_time,end_time,creator);
        }

        public static string DeleteFeepay(int FeePay_id)
        {
            return _SPdal.DeleteFeepay(FeePay_id);
        }
		
		#endregion	
	
			
	}
}
  


